{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Form","Calibration Log","Maintenance","Getting Started...","Workings"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,5,23,6],[5,4,5,6],[8,5,8,6],[9,5,9,6],[12,5,12,6],[13,5,13,6],[8,8,9,9],[12,8,13,9],[19,1,19,6],[2,1,2,9],[16,5,16,6]]}
[]
[]
[null,"THERMOMETER CALIBRATION LOG"]
[]
[]
[null,"Serial Number"]
[]
[]
[null,"Reference Temperature 1",null,null,null,null,null,"°C",{"$f":"IF(ISBLANK(F9),\"Enter Reference Temperature\",IF(ISBLANK(F10),\"Enter Actual Temperature\",IF((F9-F$24-0.01)<F10,IF(F9+F$24+0.01>F10,\"Pass\",\"Fail\"),\"Fail\")))","v":"Enter Reference Temperature"}]
[null,"Actual Temperature 1",null,null,null,null,null,"°C"]
[]
[]
[null,"Reference Temperature 2",null,null,null,null,null,"°C",{"$f":"IF(ISBLANK(F13),\"Enter Reference Temperature\",IF(ISBLANK(F14),\"Enter Actual Temperature\",IF((F13-F$24-0.01)<F14,IF(F13+F$24+0.01>F14,\"Pass\",\"Fail\"),\"Fail\")))","v":"Enter Reference Temperature"}]
[null,"Actual Temperature 2",null,null,null,null,null,"°C"]
[]
[]
[null,"Your Initials"]
[]
[]
[null,{"$f":"IF(I9=\"Fail\",Maintenance!D7,IF(I13=\"Fail\",Maintenance!D7,\"\"))","v":""}]
[]
[]
[]
[null,"Acceptable tolerance",null,null,"±",{"$f":"Maintenance!D3","v":0.5},null,"°C","(as set in maintenance tab)"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"E6","v":0},{"$f":"NOW()","v":"2020-10-06T19:00:14.760"},{"$f":"F9","v":0},{"$f":"F10","v":0},{"$f":"F13","v":0},{"$f":"F14","v":0},{"$f":"IF(I9=\"Pass\",IF(I13=\"Pass\",\"Pass\",\"Fail\"),\"Fail\")","v":"Fail"},{"$f":"F17","v":0}]

{"sheet":"Calibration Log","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5]]}
[null,null,"Test Temperature 1 ",null,"Test Temperature 2"]
["Serial Number","Date","Reference Temp. (°C)","Actual \nTemp. (°C)","Reference Temp. (°C)","Actual \nTemp. (°C)","Pass/Fail","Verifier Initials"]

{"sheet":"Maintenance","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,13,24,19],[25,13,25,19],[1,3,1,4],[6,3,10,10],[12,13,12,19],[14,13,14,19],[16,13,23,19]]}
[]
[null,"Team Names",null,"Accepted Site Tolerance"]
[null,null,null,0.5,"degC"]
[null,"Team Player 1"]
[null,"Team Player 2"]
[null,"Team Player 3",null,"Failure Message"]
[null,"Team Player 4",null,"This thermometer should removed from service immediately and reported to your supervisor.  \nPlease contact the Klipspringer service team on \nservice@klipspringer.com / 01473 461800"]
[null,"Team Player 5"]
[null,"Team Player 6"]
[null,"Team Player 7"]
[null,"Team Player 8"]
[null,"Team Player 9"]
[null,"Team Player 10",null,null,null,null,null,null,null,null,null,null,"Send To","service@klipspringer.com; "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Subject","Equipment for calibration"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Message","Hello Klipspringer Service Team,\n\nThe following instrument has been found to be out of specification. Please could we arrange to return it for recalibration?\n\nSerial Number - "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Form!E6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\n\nKind Regards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N17&N25&N26","v":"Hello Klipspringer Service Team,\n\nThe following instrument has been found to be out of specification. Please could we arrange to return it for recalibration?\n\nSerial Number - 0\n\nKind Regards"}]

{"sheet":"Getting Started...","index":3,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,0,28,10],[29,0,29,10],[24,0,24,10],[25,0,25,10],[26,0,26,10],[27,0,27,10],[23,0,23,10],[10,0,10,10],[11,0,11,10],[12,0,12,10],[13,0,13,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[5,0,5,10],[6,0,6,10],[7,0,7,10],[3,0,3,10],[4,0,4,10],[8,0,8,10],[9,0,9,10]]}
["Hello, welcome to your new thermometer calibration log tool from Klipspringer. "]
[]
["The purpose this tool is to help you keep an accurate log of your thermometer checks, and ensure any thermometers which do not pass are removed from action and sent for repair. "]
[]
["SETTING UP"]
[]
["Before you get started, you need to read through the instructions on this \"Getting Started\" tab."]
[]
["1) Go to the \"Maintenance\" (red) tab."]
[]
["2) Input the names of persons who will be using this tool (column B). You can add up to 10 names.  To do this, replace \"Team Player 1\" with the name of the first person in your team who will be using this form.  Then, replace \"Team Player 2\" with the name of the second person who will be using this form.  Complete this process as many times as necessary until all the relevant team names show in the list."]
[]
["3) Set your accepted site tolerance (field D3).  This defaults to ±0.5°C.  This is the acceptable margin your procedures allow either side of the reference temperature. "]
[]
[]
["USING THE FORM"]
[]
["1) Input the serial number of the thermometer you are checking."]
[]
["2) Test temperature 1: Input the reference temperature and your thermometer's displayed (actual) temperature into the form.  The field on the right will display \"PASS\" or \"FAIL\"."]
[]
["3) Test temperature 2: Input the reference temperature and your thermometer's displayed (actual) temperature into the form.  The field on the right will display \"PASS\" or \"FAIL\"."]
[]
["4) Choose your name from the \"Your Initials\" dropdown. "]
[]
["5) Click \"SUBMIT\".  It is important to do this even if the thermometer has failed, as this records the results on the \"Calibration Log\"."]
[]
["6) If your thermometer has passed, the form will reset ready for the next thermometer.  If your thermometer fails, a notification message will display telling you to notify your line manager.  An automatic email will also be generated to facilitate this.  Please add any additional email addresses necessary and click send on the email. "]
[]
["7) Your results can be viewed on the \"CALIBRATION LOG\" tab (green)"]

{"sheet":"Workings","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Pass "]
["Fail"]